USE [LABORATORY]
GO
/****** Object:  Table [dbo].[tblabsetup]    Script Date: 11/20/2017 14:52:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblabsetup](
	[CashBasis] [varchar](50) NULL,
	[ChargeSlipSetup] [bit] NULL,
	[UserID] [varchar](20) NULL,
	[Company] [int] NULL,
	[CompanyMarkup] [int] NULL,
	[Holiday] [bit] NULL,
	[StatMarkUp] [float] NULL,
	[Holiday2] [bit] NULL,
	[AdditionalMarkUp] [float] NULL,
	[AdditionalMarkUp2] [float] NULL,
	[AllowAlphaResult] [bit] NULL,
	[After5Option] [bit] NULL,
	[AllowWalkIn] [bit] NOT NULL,
	[AutoLock] [bit] NOT NULL,
	[AutoLockTime] [int] NULL,
	[StatOnSurcharge] [bit] NOT NULL,
	[PrintRequestonPostCharge] [varchar](2) NULL,
	[ChargePersonal] [varchar](2) NULL,
	[NewResultEntry] [varchar](2) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[tblabsetup] ([CashBasis], [ChargeSlipSetup], [UserID], [Company], [CompanyMarkup], [Holiday], [PrintRequestonPostCharge], [ChargePersonal], [NewResultEntry], [StatMarkUp], [Holiday2], [AdditionalMarkUp], [AdditionalMarkUp2], [AllowAlphaResult], [After5Option], [AllowWalkIn], [AutoLock], [AutoLockTime], [StatOnSurcharge])
 VALUES (N'3', 0, N'28', 3, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0,  30, NULL, 0, NULL, NULL, NULL)
/****** Object:  Default [DF_tblabsetup_CashBasis]    Script Date: 11/20/2017 14:52:15 ******/
ALTER TABLE [dbo].[tblabsetup] ADD  CONSTRAINT [DF_tblabsetup_CashBasis]  DEFAULT ((2)) FOR [CashBasis]
GO
/****** Object:  Default [DF_tblabsetup_ChargeSlipSetup]    Script Date: 11/20/2017 14:52:15 ******/
ALTER TABLE [dbo].[tblabsetup] ADD  CONSTRAINT [DF_tblabsetup_ChargeSlipSetup]  DEFAULT ((0)) FOR [ChargeSlipSetup]
GO